EMT Practice Test

1. Question Content...

---

Question1: A business analyst needs to develop a visualization that compares performances of every product the company sells and each product category. The CEO wants to highlight the worst- and best-performing products and categories in a meeting that beg/is in one hour Using a bar chart which two approaches should the business analyst use? (Select two.)

Question2: A business analyst has access to all of a company's data tor the past 10 years The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into What should the business analyst do to reprove the app performance?

Question3: A business analyst is creating an app for technicians. The app must meet several requirements
* Visualization labels must change according to the selected tame period
* A button to toggle between Month and Year to Date (YTD)
* Two fields combine to create one dimension that is used m several visualizations Which three options are needed to meet the requirements? (Select three.)

Question4: A user makes a selection within a sheet and then navigates to another sheet to validate the details However when the user returns to the original sheet the selection is removed What is causing this behavior?

Question5: A user makes a selection within a sheet and then navigates to another sheet to validate the details However when the user returns to the original sheet the selection is removed What is causing this behavior?

Question6: Refer to the exhibit.

A CEO wants to use a similar visualization on the company's dashboards
The visualization must meet several requirements
* Show three years of sales data
* Display sales trends by month
* Allow comparison of years using an area style display
Which set of actions should a business analyst take to meet these requirements?

Question7: A sales manager needs to visualize the company's sales. The sales manager needs to understand how sates and profitability are related over time. The visualization will be used in a printed annual report.
The business analyst has access to the following data:
* Order Dates
* Order ID
* Total Safes by Order
* Net profit margin%
* Cost of Goods Sow (COGS)
Which visualization should the business analyst use?

Question8: A business analyst needs to share a link to a specific visualization with colleagues Which steps should the business analyst use?

Question9: Several departments use an app. The business analyst needs to modify access to the sheets so that each department can access their sheets only What should me business analyst do?

Question10: After a campaign a marketing group has data that snows distinct increases of product sales over a 12-month period. The group needs to highlight the products that show the highest revenue.
What should be developed to meet this requirement?

Question11: A business analyst must add data from several tables to an existing app This app was built by a previous business analyst who used the data load editor to load some simple tables.
The changes must be implemented in the data manager
Which three actions should the business analyst take to matt these requirements? (Select three )

Question12: A business analyst is creating a story One visualization must be scaled only vertically. Which steps are needed to apply this in the storytelling view?

Question13: The sales manager is investigating the relationship between Sales and Margin to determine if this relationship is linear when choosing the dimension Customer or Product Category The sales manager wants to have the potential percentage Sales tor each Stage (initial to Won) of the sales process What are the two correct visualizations?

Question14: A business analyst is creating an app for the sales department
Users of the app most be able to create sheets and analyze data The sales department has several additional requirements
* Reuse the global sales visualization
* Create new visualizations
* The app has over 100 visualizations
Users will NOT have access to the full data model
What should be added to the master items to meet the requirement?

Question15: A customer wants to perform a regional sates analysis to learn how products set over time m different areas The business analyst needs to design a sheet in the app tor business users to perform several tasks
* Select two different groups of countries to study
* Compare sales over time between these two groups using a bar chart
* Change the group items by selecting different countries at any time
* Select a time range in the bar chart and drill-down to daily transactional sales Which steps should the business anaryst follow to meet these requirements?

Question16: A business analyst is creating a new app with sales dat
a. The visualizations must meet several requirements:
* A Bar chart mat shows sales by product group is used m multiple sheets
* A KPI object that visualizes that the total amount of sales is used once
* A Treemap mat shows margin by product group is used one time inside a Container What should be added to the master items library?

Question17: Refer to the exhibit.

What is the selection slate of light gray values?